package com.ruoyi.biz.letter.mapper;

import java.util.List;

import com.ruoyi.biz.letter.domain.BizLeaderMailbox;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.biz.report.letter.vo.CategoryCount;
import com.ruoyi.biz.report.letter.vo.CategoryReportReq;
import com.ruoyi.biz.report.letter.vo.LeaderMailboxReportResp;
import com.ruoyi.biz.report.letter.vo.ReportYearCategoryResp;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * 省住建厅官网厅长信箱Mapper接口
 *
 * @author Fei.Cong
 * @date 2024-07-11
 */
@Mapper
public interface BizLeaderMailboxMapper extends BaseMapper<BizLeaderMailbox> {

    IPage<BizLeaderMailbox> selectPageList(IPage<BizLeaderMailbox> page, @Param("entity") BizLeaderMailbox bizLeaderMailbox);

    List<LeaderMailboxReportResp> selectReport(@Param("entity") CategoryReportReq reportReq);

    List<ReportYearCategoryResp> selectReportGroupMonthAndCategory(@Param("entity") CategoryReportReq reportReq);

    List<CategoryCount> selectReportGroupCategory(@Param("currentMonth") String currentMonth);

}
